<?php
	session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>APO Cooperative Database System - Move Planholder</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="style.css" />
<link rel="stylesheet" type="text/css" href="css/ui-lightness/jquery-ui-1.8rc2.custom.css" />
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">

$(window).load(function()
{
	var temp = $("#old_employee").val();
	$("#planholder_select").load("showForm.php", {func: "planholder", employee: temp});
	$("#new_employee_select").load("showForm.php", {func: "employee", employee: temp});
});

$(document).ready(function()
{
	$("#old_employee").change(function()
	{
		var temp = $("#old_employee").val();
		$("#planholder_select").load("showForm.php", {func: "planholder", employee: temp});		
		$("#new_employee_select").load("showForm.php", {func: "employee", employee: temp});
	});
});

</script>
</head>
<body>
<div class="container ui-corner-all">
	<div class="header ui-corner-top">
  <h1>APO Cooperative Database System</h1>
</div>
<div class="divider"></div>
  <div class="wrapper">
    <div class="content">
      	<form action="movePlanHolderController.php" method="post">
		Select Employee: 
        <select name="old_employee" id="old_employee">
        <?php
        
        require_once("function.php");
        
        $con = connectToDB();
        
        $result = mysql_query("select * from employee where Pos = 'Regular'");
        while($row = mysql_fetch_array($result))
        {
            echo "<option value=\"".$row['Emp_no']."\">".$row['First_name']." ".$row['Last_name']."</option>";
        }
        ?>
        </select>
        <br />
        Select planholder to move:
        <span id="planholder_select"></span>
        <br/>
        Select new employee:
        <span id="new_employee_select"></span>
        <br />
        
        <input type="submit" />
        </form>
    </div></div>
  <div class="navigation ui-corner-all">
    <div class="navheader ui-corner-top"></div>
  	<div class="userstat">
    <?php
    	echo "<p>You are logged in as: <br/>".$_SESSION['name']."<br/></p>";
			echo "<a href=\"\">Edit</a> your profile<br />";
			echo "<a href=\"logOut.php\">Log Out</a><br />";
	?>
    </div>
    </div>
    <div class="extra ui-corner-all">
    <div class="navheader ui-corner-top"></div>
    <div class="userstat">
    <a href="managerpage.php">Back to profile page</a><br />
    	<a href="addEmployeeView.php">Add Employee</a><br />
        <a href="viewEmployeesView.php">View Employees</a><br />
        <a href="viewOtherEmployeesView.php">View Other Employees</a><br />
        <a href="movePlanHolderView.php">Move Planholders</a>
    </div>
    </div>
    <div class="footer ui-corner-bottom">
    <a href="#">Contact Us</a> | <a href="#">Terms of Use</a> | <a href="#">Trademarks</a> | <a href="#">Privacy Statement</a><br />
    Copyright &copy; 2009 . All Rights Reserved.
  </div>
</div>
</body>
</html>

